USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[MatchesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.MatchesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 09/05/08
-- Description:	Matches Table Insert
-- =============================================
CREATE PROCEDURE MatchesInsert

           @MatchId int
           ,@RedFinalScore int
           ,@BlueFinalScore int
           ,@MatchStartTime datetime
           ,@MatchEndTime datetime
           ,@LogId int
           ,@MapId int
AS
BEGIN

INSERT INTO [AnotherSuccessfulProcedure].[dbo].[Matches]
           ([MatchId]
           ,[RedFinalScore]
           ,[BlueFinalScore]
           ,[MatchStartTime]
           ,[MatchEndTime]
           ,[LogId]
           ,[MapId])
     VALUES
           (@MatchId
           ,@RedFinalScore
           ,@BlueFinalScore
           ,@MatchStartTime
           ,@MatchEndTime
           ,@LogId
           ,@MapId)

END
GO
